| Key Name |
Key Type |
Keys |
| PK_AdEnrollDegreeAuditCourse_AdEnrollDegreeAuditCourseID |
PrimaryKey |
StudentEnrollmentDpaCourseId |
| AdEnrollDegreeAuditCourse_AdEnrollId_AdCourseID_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodId, CourseId |
| AdEnrollDegreeAuditCourse_AdCourseID_N_N_IDX |
Inversion Entry |
CourseId |
| AdEnrollDegreeAuditCourse_AdEnrollDegreeAuditCourseCategoryID_N_N_IDX |
Inversion Entry |
StudentEnrollmentDpaCourseCategoryId |
| AdEnrollDegreeAuditCourse_AdEnrollID_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodId |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| StudentEnrollmentDpaCourseCategory |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentDpaCourseCategoryId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| RequiredCourse |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
RequiredCourseId |
NO |
| Course |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CourseId |
NO |
| Course |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CourseId |
NO |
| Course |
Non-Identifying |
One To Zero or More |
|
|
|
CourseId |
NO |
| StudentEnrollmentDpaCourseCategory |
Non-Identifying |
One To Zero or More |
|
|
|
StudentEnrollmentDpaCourseCategoryId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
One To Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| RequiredCourse |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
RequiredCourseId |
NO |
| Staff |
Non-Identifying |
One To Zero or More |
|
|
|
LastModifiedUserId |
NO |
| RequiredCourse |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
RequiredCourseId |
NO |
| StudentEnrollmentDpaCourseCategory |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentDpaCourseCategoryId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |